package com.defysoft.waukids;

import android.view.View;
import android.view.View.OnClickListener;
import android.widget.TextView;





public class sqltestpage extends BaseActivity_UpPhoto implements
		OnClickListener {
	TextView tv1;
	TextView tv2;
	TextView tv3;
	TextView tv4;
	TextView tv5;
	TextView tv6;
	TextView tv7;
	TextView tv8;
	TextView tv9;
	TextView tv10;
	TextView btn;
	Sqlite_Connect sc;
	

/*	@Override
	protected void onCreate(Bundle arg0) {
		super.onCreate(arg0);
		setContentView(R.layout.sqltest);
		sc=new Sqlite_Connect(this);
		tv1 = (TextView) findViewById(R.id.text1);
		tv2 = (TextView) findViewById(R.id.text2);
		tv3 = (TextView) findViewById(R.id.text3);
		tv4 = (TextView) findViewById(R.id.text4);
		tv5 = (TextView) findViewById(R.id.text5);
		tv6 = (TextView) findViewById(R.id.text6);
		tv7 = (TextView) findViewById(R.id.text7);
		tv8 = (TextView) findViewById(R.id.text8);
		tv9 = (TextView) findViewById(R.id.text9);
		tv10 = (TextView) findViewById(R.id.text10);
		btn=(TextView) findViewById(R.id.sql_btn);
		tv1.setOnClickListener(this);
		tv2.setOnClickListener(this);
		tv3.setOnClickListener(this);
		tv4.setOnClickListener(this);
		tv5.setOnClickListener(this);
		tv6.setOnClickListener(this);
		tv7.setOnClickListener(this);
		tv8.setOnClickListener(this);
		tv9.setOnClickListener(this);
		tv10.setOnClickListener(this);
		checktype();
		btn.setOnClickListener(new OnClickListener() {
			
			@Override
			public void onClick(View v) {
				sc.insert_Notice(1, 1);
				sc.insert_NoticeStamp(1, 1);
				sc.insert_Diary(1, 1);
				sc.insert_Photo(1, 1);
				sc.insert_PhotoStamp(1, 1);
				sc.insert_New_Notice(1, 1);
				sc.insert_New_Diary(1, 1);
				sc.insert_New_Photo(1, 1);
				sc.insert_New_Mas(1, 1);
				sc.insert_New_Cal(1, 1);
				checktype();
				//
			}
		});

	}*/
	
	public void checktype(){
		tv1.setText(sc.check_Notice(1, 1)+"");
		tv2.setText(sc.stamp_Notice(1, 1)+"");
		tv3.setText(sc.check_Diary(1, 1)+"");
		tv4.setText(sc.check_Photo(1, 1)+"");
		tv5.setText(sc.stamp_Photo(1, 1)+"");
		tv6.setText(sc.check_New_Notice()+"");
		tv7.setText(sc.check_New_Diary()+"");
		tv8.setText(sc.check_New_Photo()+"");
		tv9.setText(sc.check_New_Massage()+"");
		tv10.setText(sc.check_New_Caleander()+"");
		
	}

	@Override
	public void onClick(View v) {
		/*// TODO Auto-generated method stub
		switch (v.getId()) {
		case R.id.text1:
			break;
		case R.id.text2:
			sc.delete_Notice(1, 1);
			sc.delete_NoticeStamp(1, 1);
			sc.delete_Diary(1, 1);
			sc.delete_Photo(1, 1);
			sc.delete_PhotoStamp(1, 1);
			sc.delete_New_Notice(1, 1);
			sc.delete_New_Diary(1, 1);
			sc.delete_New_Photo(1, 1);
			sc.delete_New_Mas(1, 1);
			sc.delete_New_Cal(1, 1);
			checktype();
			break;
		case R.id.text3:

			break;
		case R.id.text4:

			break;
		case R.id.text5:

			break;
		case R.id.text6:

			break;
		case R.id.text7:

			break;
		case R.id.text8:

			break;
		case R.id.text9:

			break;
		case R.id.text10:

			break;
		}*/
	}
}
